{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "bbc1e087-211e-416e-9b95-5934b89db92c",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "\n",
    "import pandas as pd\n",
    "data=np.zeros([96,96], dtype = float, order = 'C')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "26fcb670-3507-4c5c-8fc8-4fc977e75e28",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[946.56, 816.  , 816.  , ..., 816.  , 816.  , 816.  ],\n",
       "       [  0.  , 946.56, 816.  , ..., 816.  , 816.  , 816.  ],\n",
       "       [  0.  ,   0.  , 946.56, ..., 816.  , 816.  , 816.  ],\n",
       "       ...,\n",
       "       [  0.  ,   0.  ,   0.  , ..., 946.56, 816.  , 816.  ],\n",
       "       [  0.  ,   0.  ,   0.  , ...,   0.  , 946.56, 816.  ],\n",
       "       [  0.  ,   0.  ,   0.  , ...,   0.  ,   0.  , 946.56]])"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for i in range(0,96):\n",
    "    for j in range(i,96):\n",
    "        if i==j:\n",
    "            data[i][j]=946.56\n",
    "        else:\n",
    "            data[i][j]=816.0\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "95a1febf-223f-46e1-92bb-bebceb1296b6",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "df=pd.DataFrame(data)\n",
    "df.to_excel('datas.xlsx',columns=df.columns,index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "296ed2c1-7b79-4d51-a9fb-63fac965775b",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
